CREATE TABLE [dbo].[Rpt_3rdPartyPayerInfo]
(
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_BT_ID] DEFAULT (''),
[PAYER_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_PAYER_NAME] DEFAULT (''),
[TRANS_NUMBER] [int] NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_TRANS_NUMBER] DEFAULT ((0)),
[APPEAL_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_APPEAL_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_CAMPAIGN_CODE] DEFAULT (''),
[PLEDGE_DATE] [datetime] NULL,
[PAYMENT_DATE] [datetime] NULL,
[PAYMENT_AMOUNT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_PAYMENT_AMOUNT] DEFAULT ((0)),
[REMAINING_BALANCE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_REMAINING_BALANCE] DEFAULT ((0)),
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_UserID_Date] DEFAULT (''),
[ORG_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_3rdPartyPayerInfo_ORG_CODE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iRpt_3rdPartyPayerInfoBT_ID] ON [dbo].[Rpt_3rdPartyPayerInfo] ([BT_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_3rdPartyPayerInfo2] ON [dbo].[Rpt_3rdPartyPayerInfo] ([CAMPAIGN_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Rpt_3rdPartyPayerInfo] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_3rdPartyPayerInfo] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_3rdPartyPayerInfo] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_3rdPartyPayerInfo] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_3rdPartyPayerInfo] TO [IMIS]
GO